{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Health Services","CSCodes","Programs","ReqCodes","ReqDD"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":95,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Health Services","index":0,"n_rows":52,"n_cols":101,"rows_kept":52,"cut":false,"hidden":false,"merged":[[46,85,46,92],[47,85,47,92],[48,85,48,92],[48,62,48,76],[45,78,45,84],[46,78,46,84],[47,78,47,84],[48,78,48,84],[35,72,35,77],[35,78,35,84],[35,0,35,62],[45,0,45,29],[45,31,45,60],[45,62,45,76],[47,62,47,76],[46,62,46,76],[46,0,48,29],[46,31,46,60],[47,31,48,60],[37,0,37,22],[37,23,37,45],[37,46,37,68],[38,0,38,22],[39,0,39,22],[38,23,38,45],[41,0,41,92],[42,0,43,92],[37,69,37,92],[38,69,38,92],[39,69,39,92],[44,0,44,92],[45,85,45,92],[34,72,34,77],[34,78,34,84],[34,0,34,1],[34,2,34,3],[34,4,34,7],[34,8,34,18],[34,19,34,48],[34,49,34,51],[34,52,34,59],[34,60,34,62],[34,63,34,69],[39,23,39,45],[38,46,38,68],[39,46,39,68],[33,72,33,77],[33,78,33,84],[33,70,33,71],[32,72,32,77],[32,78,32,84],[31,0,31,1],[31,2,31,3],[31,4,31,7],[31,8,31,18],[31,19,31,48],[31,49,31,51],[31,52,31,59],[31,60,31,62],[31,63,31,69],[32,0,32,1],[32,2,32,3],[32,4,32,7],[32,8,32,18],[32,19,32,48],[32,49,32,51],[32,52,32,59],[32,60,32,62],[32,63,32,69],[31,70,31,71],[31,72,31,77],[31,78,31,84],[30,72,30,77],[30,78,30,84],[29,0,29,1],[29,2,29,3],[29,4,29,7],[29,8,29,18],[29,19,29,48],[29,49,29,51],[29,52,29,59],[29,60,29,62],[29,63,29,69],[30,0,30,1],[30,2,30,3],[30,4,30,7],[30,8,30,18],[30,19,30,48],[30,49,30,51],[30,52,30,59],[30,60,30,62],[30,63,30,69],[29,70,29,71],[29,72,29,77],[29,78,29,84],[28,72,28,77],[28,78,28,84],[27,0,27,1],[27,2,27,3],[27,4,27,7],[27,8,27,18],[27,19,27,48],[27,49,27,51],[27,52,27,59],[27,60,27,62],[27,63,27,69],[28,0,28,1],[28,2,28,3],[28,4,28,7],[28,8,28,18],[28,19,28,48],[28,49,28,51],[28,52,28,59],[28,60,28,62],[28,63,28,69],[26,72,26,77],[26,78,26,84],[25,0,25,1],[25,2,25,3],[25,4,25,7],[25,8,25,18],[25,19,25,48],[25,49,25,51],[25,52,25,59],[25,60,25,62],[25,63,25,69],[26,0,26,1],[26,2,26,3],[26,4,26,7],[26,8,26,18],[26,19,26,48],[26,49,26,51],[26,52,26,59],[26,60,26,62],[26,63,26,69],[24,72,24,77],[24,78,24,84],[23,0,23,1],[23,2,23,3],[23,4,23,7],[23,8,23,18],[23,19,23,48],[23,49,23,51],[23,52,23,59],[23,60,23,62],[23,63,23,69],[23,70,23,71],[23,72,23,77],[23,78,23,84],[24,2,24,3],[24,4,24,7],[24,8,24,18],[24,19,24,48],[24,49,24,51],[24,52,24,59],[24,60,24,62],[24,63,24,69],[24,70,24,71],[21,78,21,84],[25,70,25,71],[25,72,25,77],[25,78,25,84],[27,70,27,71],[27,72,27,77],[27,78,27,84],[22,0,22,1],[22,2,22,3],[22,4,22,7],[22,8,22,18],[22,19,22,48],[22,49,22,51],[22,52,22,59],[22,60,22,62],[22,63,22,69],[22,72,22,77],[22,78,22,84],[21,0,21,1],[21,2,21,3],[21,4,21,7],[21,8,21,18],[21,19,21,48],[24,0,24,1],[33,85,33,92],[34,85,34,92],[35,85,35,92],[20,72,20,77],[20,78,20,84],[20,0,20,1],[20,2,20,3],[20,4,20,7],[20,8,20,18],[21,49,21,51],[21,52,21,59],[21,60,21,62],[21,63,21,69],[23,85,23,92],[24,85,24,92],[22,70,22,71],[27,85,27,92],[28,85,28,92],[29,85,29,92],[30,85,30,92],[31,85,31,92],[32,85,32,92],[21,70,21,71],[21,72,21,77],[18,85,19,92],[20,19,20,48],[18,78,19,84],[18,72,19,77],[18,70,19,71],[18,63,19,69],[18,60,19,62],[18,52,19,59],[18,49,19,51],[20,49,20,51],[20,52,20,59],[20,60,20,62],[20,63,20,69],[20,70,20,71],[35,63,35,69],[16,0,16,3],[16,4,16,7],[16,8,16,15],[16,26,16,29],[19,0,19,1],[19,2,19,3],[19,4,19,7],[18,0,18,7],[18,8,19,18],[18,19,19,48],[33,0,33,1],[33,2,33,3],[33,4,33,7],[33,8,33,18],[33,19,33,48],[33,49,33,51],[33,52,33,59],[33,60,33,62],[33,63,33,69],[12,11,13,41],[7,38,7,41],[16,30,16,33],[16,34,16,41],[26,70,26,71],[28,70,28,71],[30,70,30,71],[32,70,32,71],[34,70,34,71],[26,85,26,92],[14,26,14,41],[14,0,14,15],[20,85,20,92],[21,85,21,92],[22,85,22,92],[6,68,6,77],[7,68,7,77],[4,0,4,92],[7,64,7,66],[6,43,6,66],[10,20,10,41],[11,13,11,41],[15,0,15,3],[15,4,15,7],[15,8,15,15],[15,34,15,41],[9,0,9,41],[10,0,10,19],[11,0,11,12],[12,0,13,10],[15,26,15,29],[6,23,6,41],[7,19,7,21],[15,30,15,33],[6,0,6,21],[7,0,7,18],[7,23,7,37],[0,0,0,29],[1,0,1,29],[2,0,2,29],[0,77,2,99],[25,85,25,92],[6,78,6,92],[7,78,7,92],[9,43,9,92],[10,64,10,92],[11,56,11,92],[7,43,7,63],[15,43,15,49],[15,50,15,79],[10,43,10,63],[11,43,11,55],[12,43,13,53],[14,43,14,61],[12,54,13,92],[15,83,15,92],[14,62,14,92]]}
["SOCIAL DEVELOPMENT  Health Services Program",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEVELOPMENT SOCIAL, Programme des services de santé"]
["P.O. Box 5500, Fredericton NB, E3B 5G4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C.P. 5500 Fredericton, NB, E3B 5G4"]
["Phone: 1-844-551-3015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Téléphone: 1-844-551-3015 "]
[]
[{"$f":"IF(CR8=\"\",\"Information is missing! To ensure processing without delay, please check all applicable yellow fields, including the invoice area.\",\"All required fields are complete! Please ensure you have inputted your reference number and clicked on the submission date button.\")","v":"Information is missing! To ensure processing without delay, please check all applicable yellow fields, including the invoice area."}]
[]
["Program",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Request Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Request Status",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quote ref #:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Status of E or I"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A8,Programs!$A$2:$B$10,2,FALSE)),\" \",VLOOKUP(A8,Programs!$A$2:$B$10,2,FALSE))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(X8,ReqCodes!$A$2:$C$13,2,FALSE)),\" \",VLOOKUP(X8,ReqCodes!$A$2:$C$13,2,FALSE))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(AR8,ReqCodes!$A$3:$C$13,2,FALSE)),\" \",VLOOKUP(AR8,ReqCodes!$A$3:$C$13,2,FALSE))","v":" "},null,null,null,"Purchase ref #",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(LEFT(BM8,1)=\"A\",A8<>0,X8<>0,AR8<>0,U11<>0,N12<>0,L13<>0,AA16<>0,AE16<>0,AI16<>0,BM11<>0,BE12<>0,BC13<>0,A16<>0,E16<>0,YEAR1<>0,CA7<>0),\"E\",IF(AND(LEFT(BM8,1)=\"R\",A8<>0,X8<>0,AR8<>0,U11<>0,N12<>0,L13<>0,AA16<>0,AE16<>0,AI16<>0,BM11<>0,BE12<>0,BC13<>0,A16<>0,E16<>0,YEAR1<>0,CA7<>0),\"E\",IF(AND(LEFT(BM8,1)=\"P\",A8<>0,X8<>0,AR8<>0,U11<>0,N12<>0,L13<>0,AA16<>0,AE16<>0,AI16<>0,BM11<>0,BE12<>0,BC13<>0,CA8<>0,A16<>0,E16<>0,YEAR1<>0),\"I\",\"\")))","v":""}]
[]
["Client Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor Information"]
["Client Identification Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor Identification Number"]
["Name of Client",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor Name"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Address"]
[]
["Date of Birth",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Card Expiry Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact person (if applicable):"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E-Mail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fax:"]
["DD",null,null,null,"MM",null,null,null,"YYYY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DD",null,null,null,"MM",null,null,null,"YYYY"]
[]
["Date",null,null,null,null,null,null,null,"Manufacturer",null,null,null,null,null,null,null,null,null,null,"Service details CS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QTY",null,null,"MSRP / Fee",null,null,null,null,null,null,null,"Disc",null,null,"Sub Total",null,null,null,null,null,null,"Tx",null,"HST",null,null,null,null,null,"Total Billed",null,null,null,null,null,null,"Approved"]
["DD",null,"MM",null,"YYYY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal","Yes","No / Empty","Total Estimate","Discount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CW38","v":"0.00"},null,null,null,null,null,null,null,null,{"$f":"IF(BA21<>\"\",CU21,\"0.00\")","v":"0.00"},null,null,null,null,null,{"$f":"CT38","v":"0.00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AX21*BA21","v":0},{"$f":"IF(BA21<>\"\",ROUNDUP(BL21*IF(LEFT(BS21,1)=\"Y\",CSCodes!$A$2,\"0.00\"),3),\"0.00\")","v":"0.00"},{"$f":"IF(BA21<>\"\",ROUNDUP(BL21*IF(LEFT(BS21,1)=\"\",CSCodes!$A$2,0),3),\"0.00\")","v":"0.00"},{"$f":"IF(CS21>CT21,CS21,\"0.00\")","v":"0.00"},{"$f":"SUM(CR21*BI21)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CW39","v":"0.00"},null,null,null,null,null,null,null,null,{"$f":"IF(BA22<>\"\",CU22,\"0.00\")","v":"0.00"},null,null,null,null,null,{"$f":"CT39","v":"0.00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AX22*BA22","v":0},{"$f":"IF(BA22<>\"\",ROUNDUP(BL22*IF(LEFT(BS22,1)=\"Y\",CSCodes!$A$2,\"0.00\"),3),\"0.00\")","v":"0.00"},{"$f":"IF(BA22<>\"\",ROUNDUP(BL22*IF(LEFT(BS22,1)=\"\",CSCodes!$A$2,0),3),\"0.00\")","v":"0.00"},{"$f":"IF(CS22>CT22,CS22,\"0.00\")","v":"0.00"},{"$f":"SUM(CR22*BI22)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CW40","v":"0.00"},null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(BA23<>\"\",ROUNDUP(BL23*IF(LEFT(BS23,1)=\"Y\",CSCodes!$A$2,\"0.00\"),3),\"0.00\")","v":"0.00"},{"$f":"IF(BA23<>\"\",ROUNDUP(BL23*IF(LEFT(BS23,1)=\"\",CSCodes!$A$2,0),3),\"0.00\")","v":"0.00"},"0.00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(BA24<>\"\",ROUNDUP(BL24*IF(LEFT(BS24,1)=\"Y\",CSCodes!$A$2,\"0.00\"),3),\"0.00\")","v":"0.00"},{"$f":"IF(BA24<>\"\",ROUNDUP(BL24*IF(LEFT(BS24,1)=\"\",CSCodes!$A$2,0),3),\"0.00\")","v":"0.00"},"0.00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(BA25<>\"\",ROUNDUP(BL25*IF(LEFT(BS25,1)=\"Y\",CSCodes!$A$2,\"0.00\"),3),\"0.00\")","v":"0.00"},{"$f":"IF(BA25<>\"\",ROUNDUP(BL25*IF(LEFT(BS25,1)=\"\",CSCodes!$A$2,0),3),\"0.00\")","v":"0.00"},"0.00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(BA26<>\"\",ROUNDUP(BL26*IF(LEFT(BS26,1)=\"Y\",CSCodes!$A$2,\"0.00\"),3),\"0.00\")","v":"0.00"},{"$f":"IF(BA26<>\"\",ROUNDUP(BL26*IF(LEFT(BS26,1)=\"\",CSCodes!$A$2,0),3),\"0.00\")","v":"0.00"},"0.00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(BA27<>\"\",ROUNDUP(BL27*IF(LEFT(BS27,1)=\"Y\",CSCodes!$A$2,\"0.00\"),3),\"0.00\")","v":"0.00"},{"$f":"IF(BA27<>\"\",ROUNDUP(BL27*IF(LEFT(BS27,1)=\"\",CSCodes!$A$2,0),3),\"0.00\")","v":"0.00"},"0.00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(BA28<>\"\",ROUNDUP(BL28*IF(LEFT(BS28,1)=\"Y\",CSCodes!$A$2,\"0.00\"),3),\"0.00\")","v":"0.00"},{"$f":"IF(BA28<>\"\",ROUNDUP(BL28*IF(LEFT(BS28,1)=\"\",CSCodes!$A$2,0),3),\"0.00\")","v":"0.00"},"0.00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(BA29<>\"\",ROUNDUP(BL29*IF(LEFT(BS29,1)=\"Y\",CSCodes!$A$2,\"0.00\"),3),\"0.00\")","v":"0.00"},{"$f":"IF(BA29<>\"\",ROUNDUP(BL29*IF(LEFT(BS29,1)=\"\",CSCodes!$A$2,0),3),\"0.00\")","v":"0.00"},"0.00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(BA30<>\"\",ROUNDUP(BL30*IF(LEFT(BS30,1)=\"Y\",CSCodes!$A$2,\"0.00\"),3),\"0.00\")","v":"0.00"},{"$f":"IF(BA30<>\"\",ROUNDUP(BL30*IF(LEFT(BS30,1)=\"\",CSCodes!$A$2,0),3),\"0.00\")","v":"0.00"},"0.00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(BA31<>\"\",ROUNDUP(BL31*IF(LEFT(BS31,1)=\"Y\",CSCodes!$A$2,\"0.00\"),3),\"0.00\")","v":"0.00"},{"$f":"IF(BA31<>\"\",ROUNDUP(BL31*IF(LEFT(BS31,1)=\"\",CSCodes!$A$2,0),3),\"0.00\")","v":"0.00"},"0.00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(BA32<>\"\",ROUNDUP(BL32*IF(LEFT(BS32,1)=\"Y\",CSCodes!$A$2,\"0.00\"),3),\"0.00\")","v":"0.00"},{"$f":"IF(BA32<>\"\",ROUNDUP(BL32*IF(LEFT(BS32,1)=\"\",CSCodes!$A$2,0),3),\"0.00\")","v":"0.00"},"0.00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(BA33<>\"\",ROUNDUP(BL33*IF(LEFT(BS33,1)=\"Y\",CSCodes!$A$2,\"0.00\"),3),\"0.00\")","v":"0.00"},{"$f":"IF(BA33<>\"\",ROUNDUP(BL33*IF(LEFT(BS33,1)=\"\",CSCodes!$A$2,0),3),\"0.00\")","v":"0.00"},"0.00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(BA34<>\"\",ROUNDUP(BL34*IF(LEFT(BS34,1)=\"Y\",CSCodes!$A$2,\"0.00\"),3),\"0.00\")","v":"0.00"},{"$f":"IF(BA34<>\"\",ROUNDUP(BL34*IF(LEFT(BS34,1)=\"\",CSCodes!$A$2,0),3),\"0.00\")","v":"0.00"},"0.00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(BA35<>\"\",ROUNDUP(BL35*IF(LEFT(BS35,1)=\"Y\",CSCodes!$A$2,\"0.00\"),3),\"0.00\")","v":"0.00"},{"$f":"IF(BA35<>\"\",ROUNDUP(BL35*IF(LEFT(BS35,1)=\"\",CSCodes!$A$2,0),3),\"0.00\")","v":"0.00"},"0.00",0]
["Total payment:   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BL21:BR35)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(BU21:BZ35)","v":0},null,null,null,null,null,{"$f":"SUM(CA21:CG35)","v":0},null,null,null,null,null,null,{"$f":"SUM(CH21:CO35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate","Invoice",true,"SUB Estimate","SUB Invoice","Sub True"]
["Equipment Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manufacturer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Model",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serial Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($CR$8=\"E\",I21<>\"\",T21<>\"\",AX21<>\"\",BA21<>\"\",BI21<>\"\"), BL21+BU21,\"0.00\")","v":"0.00"},{"$f":"IF(AND($CR$8=\"I\",A21<>\"\",C21<>\"\",E21<>\"\",I21<>\"\",T21<>\"\",AX21<>\"\",BI21<>\"\",BA21<>\"\"),BL21+BU21,\"0.00\")","v":"0.00"},{"$f":"IF($CR$8=\"I\",CS38,CR38)","v":"0.00"},{"$f":"IF(AND($CR$8=\"E\",I21<>\"\",T21<>\"\",BA21<>\"\"),IF(AND(AX21<>\"\",BI21<>\"\"),ROUNDUP(CR21-(CR21*BI21),3),\"0.00\"),\"0.00\")","v":"0.00"},{"$f":"IF(AND($CR$8=\"I\",A21<>\"\",C21<>\"\",E21<>\"\",I21<>\"\",T21<>\"\",BA21<>\"\"),IF(AND(AX21<>\"\",BI21<>\"\"),ROUNDUP(CR21-(CR21*BI21),3),\"0.00\"),\"0.00\")","v":"0.00"},{"$f":"IF($CR$8=\"I\",CV38,CU38)","v":"0.00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($CR$8=\"E\",I22<>\"\",T22<>\"\",AX22<>\"\",BA22<>\"\",BI22<>\"\"), BL22+BU22,\"0.00\")","v":"0.00"},{"$f":"IF(AND($CR$8=\"I\",A22<>\"\",C22<>\"\",E22<>\"\",I22<>\"\",T22<>\"\",AX22<>\"\",BI22<>\"\",BA22<>\"\"),BL22+BU22,\"0.00\")","v":"0.00"},{"$f":"IF($CR$8=\"I\",CS39,CR39)","v":"0.00"},{"$f":"IF(AND($CR$8=\"E\",I22<>\"\",T22<>\"\",BA22<>\"\"),IF(AND(AX22<>\"\",BI22<>\"\"),ROUNDUP(CR22-(CR22*BI22),3),\"0.00\"),\"0.00\")","v":"0.00"},{"$f":"IF(AND($CR$8=\"I\",A22<>\"\",C22<>\"\",E22<>\"\",I22<>\"\",T22<>\"\",BA22<>\"\"),IF(AND(AX22<>\"\",BI22<>\"\"),ROUNDUP(CR22-(CR22*BI22),3),\"0.00\"),\"0.00\")","v":"0.00"},{"$f":"IF($CR$8=\"I\",CV39,CU39)","v":"0.00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($CR$8=\"E\",I23<>\"\",T23<>\"\",AX23<>\"\",BA23<>\"\",BI23<>\"\"), BL23+BU23,\"0.00\")","v":"0.00"},"0.00","0.00","0.00","0.00","0.00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00","0.00","0.00","0.00","0.00","0.00"]
["Additional information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00","0.00","0.00","0.00","0.00","0.00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00","0.00","0.00","0.00","0.00","0.00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00","0.00","0.00","0.00","0.00","0.00"]
["Health Services Only",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00","0.00","0.00","0.00","0.00","0.00"]
["REFUSED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APPROVED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approved Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approval sub",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00","0.00","0.00","0.00","0.00","0.00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APPROVAL CODE PROVIDED BY HEALTH SERVICES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision sub",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00","0.00","0.00","0.00","0.00","0.00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payment sub",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00","0.00","0.00","0.00","0.00","0.00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invoice ver.",null,null,null,null,null,null,"HSOCT212019",null,null,null,null,null,null,null,null,null,"0.00","0.00","0.00","0.00","0.00","0.00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00","0.00","0.00","0.00","0.00","0.00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00","0.00","0.00","0.00","0.00","0.00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.00","0.00","0.00","0.00","0.00","0.00"]

{"sheet":"CSCodes","index":1,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Tax",null,"DD","MM","YYYY"]
[0.15,null,1,1]
[null,null,2,2]
[null,null,3,3]
[null,null,4,4]
[null,null,5,5]
[null,null,6,6]
[null,null,7,7]
[null,null,8,8]
[null,null,9,9]
[null,null,10,10]
[null,null,11,11]
[null,null,12,12]
[null,null,13]
[null,null,14]
[null,null,15]
[null,null,16]
[null,null,17]
[null,null,18]
[null,null,19]
[null,null,20]
[null,null,21]
[null,null,22]
[null,null,23]
[null,null,24]
[null,null,25]
[null,null,26]
[null,null,27]
[null,null,28]
[null,null,29]
[null,null,30]
[null,null,31]

{"sheet":"Programs","index":2,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Programs","PC","Contact / Registration"]
["Basic Adaptive Aids","BA","Contact person (if applicable)"]
["Mobility Aids","MA","Contact person (if applicable)"]
["Complex Adaptive Aids","CA","Contact person (if applicable)"]

{"sheet":"ReqCodes","index":3,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Type","ABR1","AB2"]
["New equipment","NE","NE"]
["New services","NS","NS"]
["Rental","RNT","RNT"]
["Repairs / Maintenance","RM","RM",null,null,null,"     "]
["New services -","NS","NS"]
["New equipment -","NE","NE"]
[]
["Request for approval","APR","E"]
["Request for approval - Urgent","APU","E"]
["Request for payment","PMT","I"]
["Request for revision","REV","E"]
["Request for revision - Urgent","RVU","E"]

{"sheet":"ReqDD","index":4,"n_rows":29,"n_cols":21,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Basic Adaptive Equipment",null,"Basic Adaptive Equipment","BASTATS",null,"Dental - Denturist","DENTSTATS","Hearing Aid","HEARSTATS","Medical Services","MEDICALSTATS","Mobility Equipment","MOBEQSTATS","Orthopedic","ORTHOSTATS","Prosthetic","PROSTSTATS","Respiratory Services","RESPSTATS","Standard Adaptive Equipment","SAEQSTATS"]
["Dental - Denturist",null,"New equipment","Request for approval",null,"New equipment","Request for approval","New equipment","Request for approval","New equipment","Request for approval","New equipment","Request for approval","New equipment","Request for approval","New equipment","Request for approval","New equipment","Request for approval","New equipment -","Request for approval"]
["Hearing Aid",null,"New services","Request for approval - Urgent",null,"New services","Request for approval - Revision","New services","Request for approval - Urgent","New services","Request for approval - Urgent","New services","Request for approval - Urgent","Repairs / Maintenance","Request for approval - Urgent","New services","Request for payment","New services","Request for payment","New services -","Request for approval - Urgent"]
["Medical Services",null,"Repairs / Maintenance","Request for revision",null,"Repairs / Maintenance","Request for payment","Repairs / Maintenance","Request for payment","Repairs / Maintenance","Request for payment","Repairs / Maintenance","Request for revision",null,"Request for payment","Repairs / Maintenance",null,"Repairs / Maintenance",null,"Repairs / Maintenance","Request for revision"]
["Mobility Equipment",null,null,"Request for revision - Urgent",null,null,null,null,null,"Rental",null,null,"Request for revision - Urgent",null,null,null,null,"Rental",null,null,"Request for revision - Urgent"]
["Orthopedic",null,null,"Request for payment",null,null,null,null,null,null,null,null,"Request for payment",null,null,null,null,null,null,null,"Request for payment"]
["Prosthetic"]
["Respiratory Services"]
["Standard Adaptive Equipment"]
[]
[null,null,"Basic Adaptive Aids","BAEQDD"]
[null,null,"Dental - Denturist","DENTISTDD"]
[null,null,"Hearing Aid","HEARINGAIDDD"]
[null,null,"Medical Services","MEDICALDD"]
[null,null,"Mobility Aids","MEQDD"]
[null,null,"Orthopedic","ORTHODD"]
[null,null,"Prosthetic","PROSTHETICDD"]
[null,null,"Respiratory Services","RESPSERVDD"]
[null,null,"Complex Adaptive Aids","SAEQDD"]
[]
[null,null,"Basic Adaptive Aids","BASTATS"]
[null,null,"Dental - Denturist","DENTSTATS"]
[null,null,"Hearing Aid","HEARSTATS"]
[null,null,"Medical Services","MEDICALSTATS"]
[null,null,"Mobility Aids","MOBEQSTATS"]
[null,null,"Orthopedic","ORTHOSTATS"]
[null,null,"Prosthetic","PROSTSTATS"]
[null,null,"Respiratory Services","RESPSTATS"]
[null,null,"Complex Adaptive Aids","SAEQSTATS"]